0) { $_categ_data = mysqli_fetch_array($_categ_result,MYSQLI_ASSOC); $category_desc = $_categ_data['nama_kategori']; $kode_kategori = $_categ_data['idkategori']; } $totalPage_sql = "SELECT count(idproduk) as TOTAL FROM v_product_qty WHERE init_kategori = '".$category_id."' AND discountinue = 0" ; $totalPage_data = mysqli_query($MyCon,$totalPage_sql); $totalPage_rec = mysqli_fetch_array($totalPage_data,MYSQLI_ASSOC); $totalPage = ceil($totalPage_rec['TOTAL'] / $results_per_page); $item_sql = "SELECT v.*,p.seo_nama_produk,fnc_gambarutama(v.idproduk) foto_utama, fnc_cariharga(v.idproduk,'STOCK') curstock FROM v_product_qty v, produk p WHERE v.init_kategori = '".$category_id."' AND v.discountinue = 0 AND v.idproduk = p.idproduk ORDER BY v.idproduk ASC LIMIT $start_from, ".$results_per_page; } else { $totalPage_sql = "SELECT count(idproduk) as TOTAL FROM v_product_qty WHERE discountinue = 0" ; $totalPage_data = mysqli_query($MyCon,$totalPage_sql); $totalPage_rec = mysqli_fetch_array($totalPage_data,MYSQLI_ASSOC); $totalPage = ceil($totalPage_rec['TOTAL'] / $results_per_page); $item_sql = "SELECT v.*,p.seo_nama_produk,fnc_gambarutama(v.idproduk) foto_utama, fnc_cariharga(v.idproduk,'STOCK') curstock FROM v_product_qty v, produk p WHERE v.discountinue = 0 AND v.idproduk = p.idproduk ORDER BY v.idproduk ASC LIMIT $start_from, ".$results_per_page; } if (strtolower($tokoUserEmail) == "ajm_widjajas@yahoo.com") { if ($kode_kategori != 0) { $cari_promokategory = mysqli_query($MyCon,"SELECT id_produk FROM promo_cat_produk WHERE id_cat = $kode_kategori AND NOW() between tgl_awal AND tgl_ahir "); if (mysqli_num_rows($cari_promokategory) > 0) { while($row = $cari_promokategory->fetch_array()) { $promo_categori[] = $row["id_produk"]; } } } } $item_record = mysqli_query($MyCon,$item_sql); ?> <?php echo "Kategori " . $category_desc . " | " . $WebTitle; ?>

Shop

  2. Product Category
Sofa
Kursi Lengan
Kursi
Meja Makan
Audio Video Rak
Meja
Rak Serbaguna
Kamar Tidur
Nakas
Lemari Pakaian Anak
Perlengkapan Dapur
Perlengkapan Kamar Mandi
Lemari Pakaian
Rak Sepatu
Meja Tulis
Bar sets
Perhiasan Lampu
Karpet
Meja Rias
Type
> >
Update search Now
Showing all 50 of 3,250 items
0) { while ($rowProduct = mysqli_fetch_array($item_record,MYSQLI_ASSOC)) { $prodimg = "upload/produk2020/".$rowProduct['foto_utama']; $produrl = "pdetail/".$rowProduct['seo_nama_produk']; $prodname = $rowProduct['nama_produk']; $prodprice = $rowProduct["harga_jual"]; $proddesc = $rowProduct["deskripsi"]; $diskon = $rowProduct["diskon"]; $prodid = $rowProduct["idproduk"]; if (is_null($rowProduct["curstock"])) { $curstock = 0; } else { $curstock = $rowProduct["curstock"]; } $ada_promo = ""; if (isset($promo_categori)) { foreach ($promo_categori as $procat => $val) { if ($val == $prodid) { $ada_promo = "[ ADA PROMO ]"; break; } } } if ($tokoUserEmail != "") { $hargaCoret = $rowProduct["harga_jual"]; $prodprice = $hargaCoret - (($hargaCoret * $diskon)/100); } ?>
Promo Kategori " . $prodname . ""; } ?>

    1 or $page_no == $totalPage) { if ( $page_no > 1 ) { $page_noy = $page_no - 1; echo "
    • "; } } for ($noPages = 1; $noPages <= $totalPage; $noPages++) { if ($noPages == $page_no) { echo "
  • "; } else { echo "
  • "; } echo "".$noPages."
    • "; } if ($totalPage > 1 && $page_no != $totalPage) { $page_nox = $page_no + 1; echo "
    • "; } ?>